select * from products where pro_name like '%Spring%dresses%' or pro_des like '%Spring%dresses%'union all select * from products where (pro_name like '%Spring%' or pro_des like '%Spring%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%Spring%dresses%' or pro_des not like '%Spring%dresses%')
2015 Cheap and Cute Lilac Beading Sweetheart Dama Dresses with Pick Ups
Cheap Dark Green Sweetheart Dama Dresses with Beading and Appliques
Cheap Ball Gown Pink and Black Strapless Dama Dresses with Appliques and Ruffles
2015 Cheap Red Strapless Dama Dresses with Beading and Hand Made Flower
Cheap High Low Sweetheart Wine Red Beading Dama Dresses
New Sweetheart Sweep Train Beading and Ruffles Princesita Dress for 2015
Popular Beading and Ruffles Red Princesita Dress for 2015
Wonderful Embroidery and Ruffles 2015 Princesita Dress in Pink
Sequins and Ruffles Ball Gown 2015 White Princesita Dress
Latest Appliques Princesita Dress in Light Yellow For 2015
Simple Sweetheart Sequins Princesita Dress in Rose Pink For 2015
2015 Elegant Appliques and Ruffles Princesita Dress in Baby Blue
2015 Appliques and Ruffles Lilac Princesita Dress with Hand Made Flowers
2015 Top Selling Wedding Shawl with Open Front
Ivory Faux Fur Shawl With Button Front Closure
2015 Beautiful Rabbit Fur Shawls with Rhinestone
Pearl Front Closure Rabbit Fur 2015 Pretty Shawls
2015 The Most Popular White Wraps with Faux Fur
Faux Fur Open Front Shawls for Wedding Party
2015 Perfect Open Front Wraps with Faux Fur
2015 Ivory Faux Fur Shawl With Button Front Closure
2015 Elegant Open Front Wraps for Wedding Party
Open Front 2015 Wonderful Shawls in White
Fox Fringed Fur 2015 Remarkable Wraps with Button
Modern Pearl Front Closure Faux Fur Wraps for 2015
Fold over Collar Special Occasion Rabbit Fur Shawls
2015 White Rabbit Fur Shawls with Long Sleeves
Long Sleeves 2015 Popular Shawls in White
2015 High Quality Bridal Shawl with Open Front
Top Selling Open Front Wraps in White